how to select rows with no matching entry in another table
143
SELECT Name, Gender,country, Salary, DeptName
FROM tbl_Employee
LEFT OUTER JOIN tbl_Department
ON tbl_Employee.DepartmentId = tbl_Department.DeptId
where tbl_Employee.DepartmentId is null